﻿CREATE TABLE [cex].[User] (
    [Id]                 INT            IDENTITY (1, 1) NOT NULL,
    [SiteId]             INT            NULL,
    [EmailAddress]       VARCHAR (255)  NOT NULL,
    [Password]           VARCHAR (255)  NOT NULL,
    [Salt]               INT            NOT NULL,
    [FirstName]          VARCHAR (100)  NOT NULL,
    [LastName]           VARCHAR (100)  NOT NULL,
    [Department]         VARCHAR (100)  NULL,
    [CountryId]          INT            NOT NULL,
    [State]              VARCHAR (100)  NULL,
    [Comment]            VARCHAR (2000) NULL,
    [ThumnailId]         INT            NOT NULL,
    [Anon]               BIT            NOT NULL,
    [Relative]           BIT            NOT NULL,
    [EmailAuthenticated] BIT            NOT NULL,
    [Created]            DATETIME       NOT NULL,
    [Deleted]            BIT            NOT NULL,
    [CID]                TIMESTAMP      NOT NULL
);

